USE [IntTester]
GO

/****** Object:  StoredProcedure [dbo].[pr_SaveTestRun]    Script Date: 03/10/2014 16:38:41 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[pr_SaveTestRun]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[pr_SaveTestRun]
GO

USE [IntTester]
GO

/****** Object:  StoredProcedure [dbo].[pr_SaveTestRun]    Script Date: 03/10/2014 16:38:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[pr_SaveTestRun]
	-- Add the parameters for the stored procedure here
	@testName nvarchar(500), 
	@testFileName nvarchar(500), 
	@testFileLocation nvarchar(1000), 
	@runDate DateTime ,
	@runStatus  nvarchar(50), 
	@message  nvarchar(max),
	@resultFolderLocation  nvarchar(max),
	@browser  nvarchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	Insert into dbo.TestRun
	(testName, testFileName, testFileLocation, runDate, runStatus, message,resultFolderLocation,browser)
	VALUES
	(@testName, @testFileName, @testFileLocation, @runDate, @runStatus, @message,@resultFolderLocation,@browser)
END

GO


